How to Install 32 bit ODBC Driver for Excel 2010 and Later (xlsx)

Description

When configuring a 32 bit ODBC datasource for an Excel file created in Microsoft Office 2010 or above you need to have the driver for .xlsx files. The 32 bit version of this driver is not installed by default with Office 2013 or above. To add this driver you need to install the Microsoft Access Database Engine 2010 Redistributable.

How to install the 32 bit ODBC driver for Excel 2010 and above

  1. Download the Microsoft Access Database Engine 2010 Redistributable
    https://www.microsoft.com/en-US/download/details.aspx?id=13255

  2. Select the AccessDatabaseEngine.exe as this contains the 32 bit drivers.

  3. Run the executable
  4. Click Yes when prompted by User Account Control
  5. Click Next when the Microsoft Access database engine 2010 (English) Setup begins
  6. Check the box to accept the License Agreement and click Next
  7. Confirm the install directory (default: C:\Program Files (x86)\Microsoft Office\) and click Install
  8. Click OK to complete the setup